﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using QuanLyDoiXe.Lop_du_lieu;

namespace QuanLyDoiXe.lop_doi_tuong
{
    class lop_chitiethoadon
    {
        string MCTHD,MKH,Mhanghoa,Mtrangthai,Diachi;
        int Soluong;
        public lop_chitiethoadon(){}
        public lop_chitiethoadon(string MCTHD,string MKH,string Mhanghoa,string Mtrangthai,string Diachi,int Soluong)
        {
            this.MCTHD = MCTHD;
            this.MKH = MKH;
            this.Mhanghoa = Mhanghoa;
            this.Mtrangthai = Mtrangthai;
            this.Diachi = Diachi;
            this.Soluong = Soluong;
        }
        #region Các phương thức hoạt động
        public bool taomoi()
        {
            Lop_lay_du_lieu dl = new Lop_lay_du_lieu();
            if (dl.thucthitruyvan("insert into chitiethoadon values ('" + MCTHD + "','" + MKH + "','" + Mhanghoa + "','" + Mtrangthai + "',N'" + Diachi + "','" + Soluong + "')") == 1)
            {
               lop_ket_noi.huyketnoi();
               return true;
            }
            else
            {
                lop_ket_noi.huyketnoi();
                return false;
            }
        }
        public bool capnhat()
        {
            Lop_lay_du_lieu dl = new Lop_lay_du_lieu();
            if (dl.thucthitruyvan("update chitiethoadon set MKH='" + MKH + "',Mhanghoa='" + Mhanghoa + "',Mtrangthai='" + Mtrangthai + "',Diachi=N'" + Diachi + "',Soluong='" + Soluong + "' where MCTHD='" + MCTHD + "'") == 1)
            {
                lop_ket_noi.huyketnoi();
                return true;
            }
            else
            {
                lop_ket_noi.huyketnoi();
                return false;
            }
        }
        public bool xoa()
        {
            Lop_lay_du_lieu dl = new Lop_lay_du_lieu();
            if (dl.thucthitruyvan("delete from chitiethoadon where MCTHD='" + MCTHD + "'") == 1)
            {
                lop_ket_noi.huyketnoi();
                return true;
            }
            else
            {
                lop_ket_noi.huyketnoi();
                return false;
            }
        }
        #endregion
    }
}
